SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddSurveyTheme]

	(
	@param_topic NVARCHAR(100),
	@param_type NVARCHAR(50),
	@param_add_time SMALLDATETIME,
	@param_user_add NVARCHAR(50),
	@param_start_time SMALLDATETIME,
	@param_end_time SMALLDATETIME
	
	)

AS
	/* SET NOCOUNT ON */
	
	INSERT INTO dbo.JOL_SurveyManagement_Theme
	        ( topic ,
	          type ,
	          add_time ,
	          user_add ,
	          visit_times ,
	          start_time ,
	          end_time
	        )
	VALUES  ( @param_topic , -- topic - nvarchar(100)
	          @param_type , -- type - nvarchar(50)
	          @param_add_time , -- add_time - smalldatetime
	          @param_user_add, -- user_add - nvarchar(50)
	          0 , -- visit_times - int
	          @param_start_time , -- start_time - smalldatetime
	          @param_end_time  -- end_time - smalldatetime
	        )
	RETURN
GO
